Skip to main content

Snowflake Integration Setup

Enhanced Security

This integration uses public key authentication for enhanced security and compliance with Snowflake's latest security best practices. Password-based authentication is being deprecated - see our migration guide for details.

Quick Setup Process​

Setting up your Snowflake integration with nOps is straightforward:

  1. Navigate to Integration: Access your Inform Integrations and choose "Snowflake"

  2. Enter Account Identifier: Provide your Snowflake account identifier in the required format

  3. Get Setup Instructions: Click "View Instructions" to receive customized SQL commands and detailed setup steps

Account Identifier Format​

Required: Only the account identifier (without the full URL)

  • Examples:
    • xy12345.us-east-1
    • abc123.eu-west-1
    • ngb14322.us-east-1
Simplified Configuration

Once you enter your account identifier, the platform will provide you with personalized setup instructions including all necessary SQL commands, the nOps public key, and step-by-step configuration guidance.

What You'll Get in the Instructions​

After entering your account identifier and clicking "View Instructions", you'll receive:

  • Customized SQL Commands: Pre-configured with your account details and the nOps public key
  • Database and Role Setup: Commands to create the required nOps database, role, user, and warehouse
  • View Creation: SQL to set up the necessary views for data integration
  • Verification Steps: Commands to test your setup
  • IP Allowlist Information: Network configuration details if needed

Troubleshooting​

Common Integration Issues​

  1. Account Identifier Format

    • Ensure you're using only the account identifier (e.g., xy12345.us-east-1)
    • Do not include the full Snowflake URL or protocol

  2. Setup Prerequisites

    • You must have ACCOUNTADMIN privileges in Snowflake to complete the setup
    • Ensure you're configuring from the organization admin account

  3. Network Configuration

    • If your Snowflake account uses IP allowlisting, the required IP will be provided in the setup instructions

Getting Help​

If you encounter issues during setup:

  1. Check the UI Instructions: The in-app setup guide provides detailed troubleshooting steps
  2. Contact Support: Reach out to nOps support with your account identifier and any error messages

Benefits of Public Key Authentication​

  • Enhanced Security: No stored passwords that can be compromised
  • Compliance: Aligns with Snowflake's latest security recommendations
  • Future-Proof: Compatible with evolving Snowflake security requirements